Bank Reconciliation Initialisation
If Tourplan NX accounting has been used for a time prior to the Bank Reconciliation being used, then a Bank Reconciliation starting date needs to be determined and any existing transactions dated prior to the reconciliation start date need to be tagged to prevent them from appearing in the reconciliation in the future.
In other words remove by tagging all those transactions that will not appear on a future bank statement page.
Bank Reconciliation Initialisation
-
From the Home menu, select
Financials > Accounting > Bank Reconciliation.
-
When the Bank Reconciliation Setup is completed and saved, the
Statement Details Screen displays with no reconciled pages listed. Click Exit.
-
The
Bank Account screen will display with the Reconciled Pages tab open. Either click Insert or the Page Line.
-
Select the
Reconciliation Date, tag check box(es) for the required transaction lines to be included in the initialisation, and click Audit.
-
Click
Save to keep the changes.
-
Click
Exit to discard any changes.
About Bank Reconciliation
-
When the Bank Reconciliation Setup is completed and saved, the
Statement Details screen displays with no reconciled pages listed. Click the Grey Exit Button.
Any edits to the date etc. can be made in the next screen. -
On Exit, the
Reconciled Pages tab is highlighted and the Initialisation Page Number and Starting Page Balance values have defaulted to it. The Opening Page Balance can not be changed.
- Click either the Grey Insert button or the Page line.
-
The
statement details page will open with the Page Number, Opening and Closing page balances as entered in the details screen defaulted into it. A list of unreconciled transactions displays.
Example Bank Reconciliation - Initialisation Page
NOTE: When at least one transaction line has been tagged, an Audit Button becomes active. Clicking the Audit Button will open the currently highlighted transaction to provide full details of it.
About Bank Reconciliation Fields
Reconciliation Date (Date-Time)
This defaults to todays date, but can be overridden to be the bank statement date.
Reconciliation User (Char 30)
This field defaults to the current logged in user, it can be overridden to another user name if required.
Page Number (Char 10)
The page number automatically increments by 1 from the previous reconciliation page number. This should match the page number of the bank statement being reconciled. The page number can be edited, but only if the accounting period the reconciliation is in is an open period.
Closing Page Balance (Numeric 16,4)
Enter the closing balance from the bank statement being reconciled.
Opening Page Balance (Display Only)
The closing balance from the previously reconciled bank statements